Main
Michael Hanna
Data Engineer
WORK IN PROGRESS
Professional Experience
Data Engineer II
EQT Corporation
Pittsburgh, PA
Jun 2017 - Current
- Write R and SQL scripts to Extract, Transform, and Load data (ETL) from the authoritative sources to enable data-driven decisions for the business.
- Develop insights using Tibco Spotfire, Microsoft Power BI, and R Shiny as needed.
- Report quarterly drilling performance and KPIs to the management.
- Create and deploy all Wellview drilling data audits to ensure data reliability.
- Manage work using cases and work items in Salesforce and repositories in Github.
Wells Performance Analyst
BP
Anchorage, Alaska
Apr 2012 - May 2017
- Maintain the EDM Database through OpenWells and Compass Data Validation and Quality Control.
- Perform End of Well Data Audits and End of Well Reporting.
- Develop Automated Tools in Excel and Spotfire which help the Drilling Engineers and Well Site Leaders in reporting, monitoring, and performance tracking of their Wells Data such: Drilling Data Reporter, AWGRS NPT Analysis in Spotfire, EDM Well Performance Analysis in Spotfire, Wellbore Integrity Testing Criteria Calculator, Automated Tally Template, Rig Elevation Form, Well Initialization Template, and Automated Monthly WIPs Template.
- Compile and manipulate data from different sources to assist with technical analysis (EDM, AWGRS, Finder, SAP Business Objects,…etc.)
- Assist in Drilling Performance Benchmarking and KPIs.
- Participate in publishing and reviewing the monthly Work In Progress (WIPs) reports.
- Update the company legacy tools in order to comply with the new policies and best practices.
- Participate in testing Landmark new releases and provide acceptance criteria to the management.
- Identify and manage bugs/issues in the current version of OpenWells and Compass.
- Perform ad-hoc data querying and analysis as requested.
- Recommend new workflows based on learning from past inefficiencies.
- Act as point of contact for any EDM related questions.
DRILLING APPS
Proficient with Landmark EDM Suite (OpenWells, Compass, Data Analyzer, and Profile)
Proficient with Wellview
Proficient with Petrobeacon Spotlight Audit App
Proficient with Genesis Analyzer, Designer and Data Entry System (DES)
Proficient with the Drilling Performance KPIs and End of Well Reporting
REFERENCES
Scan this with your iPhone camera to look at recommendations on my LinkedIn profile.
Last updated on 2020-02-17
Senior Drilling Data Management Engineer
MCS Freezone (Modern Computing Services)
Cairo, Egypt
Mar 2006 - Sep 2011
- Professional with MCS Drilling Data Management System (research, design, test, QC, installation, configuration, troubleshooting, training, support, documentation, and database administration)
- Field Drilling Data Management (data collection, data entry, data QC, and daily reporting)
- Drilling activity reporting (daily activity reporting, final well reporting, managerial and statistical reporting, NPT and Lost time reporting)
- Drilling Performance Analysis, NPT and root cause analysis, and learn curve management
- Provide training and support to Drilling Supervisors and Engineers in both office and rig site
- Develop installation guides and training manuals
- Kongsberg Real-Time Drilling Data Management System
- PMAC Systems sand monitoring tools and software
Roughneck
Global SantaFE Corporation, Offshore Key Manhattan Jackup Rig
Port Said, Egypt
Nov 2004 - Feb 2006
Education
Cairo University - Faculty of Engineering
B.Sc. in Petroleum Engineering
Cairo, Egypt
1998 - 2003
Selected achievements
EQT
- Developed ‘write_2_azure’ function in R to QC the written data frames prior to truncating existing tables by adding proper error handling techniques and logging the errors in the relevant database. This prevented erroneous data to be fed downstream and improved the stability of our scripts. The function was later promoted in the company package for the general consumption.
- Automated weekly emails pulling data from Azure SQL database and sending them to joint-venture partners using R.
- Created a Drilling Sandbox which is an interactive Spotfire dashboard taking inputs from the user to tweak the settings and axes to answer endless performance questions which ended, multiple times, in the earning call presentations.
BP
- Developed and maintained the first Spotfire dashboards in GWO Alaska. Received global recognition from BP.
- Created “Wellbore Integrity Testing Criteria Calculator” which determines if the test pressure results meet the acceptance criteria according to “BP Site Technical Practice CRT-AK-10-45: Working with Pressure”.
EGYPT
- Implemented the first Kongsberg real-time drilling data management system in the Egyptian market.
- Awarded a certificate for my successful participation in the “In-House SPE Student Technical Paper Contest”, Cairo, Egypt, 2003.